Method GetOHDtl

Type: FusionOSServices.Controllers.OnBaseController

Summary

This service returns AP voucher/open hold detail records for OnBase: OhPrNo, OhRef, OhStatus, OhCheckNo, OhCkDt, OhRefDt, OhGlKey, OhJlKey, OhJlObj, OhChargeAmt, OhDiscAmt, OhDistAmt, OhDutyAmt, OhTaxAmt, OhTaxAmt2, OhPrItem, OhMisc. Supports server-side pagination via TakeRows and SkipRows query parameters (e.g. TakeRows=100&SkipRows=0). Recommended for this large table (~22k rows).

Example

GET https://fusion.superion.com/FusionOSServices/v0/ONESolution/OnBase/OHDtl?TakeRows=100&SkipRows=0

Sample Code

using System.Net;
using Newtonsoft.Json.Linq;

public void MethodName(parms){

    string uri = "https://fusion.superion.com/FusionOSServices/v0/ONESolution/OnBase/OHDtl";

    using (WebClient wc = new WebClient())
    {
        wc.Headers.Add("Content-Type", "application/json");
        // Replace "ID" with supplied AppID
        wc.Headers.Set("X-APPID", "ID");
        // Replace "KEY" with supplied AppKey
        wc.Headers.Set("X-APPKEY", "KEY");

        string result = wc.DownloadString(uri);
        var response = JObject.Parse(result);
        var records = (JContainer)response["values"];

        foreach (var record in records)
        {
            string ohPrNo = (string)record["ohPrNo"];
            string ohRef = (string)record["ohRef"];
            string ohStatus = (string)record["ohStatus"];
        }
    }
}

Sample Responses

JSON


                        
            {
              "values": [
                {
                  "ohPrNo": "R04506",
                  "ohRef": "INV001",
                  "ohStatus": "WP",
                  "ohCheckNo": "",
                  "ohCkDt": null,
                  "ohRefDt": "2024-01-10T00:00:00",
                  "ohGlKey": "5000000000",
                  "ohJlKey": "SB001",
                  "ohJlObj": "01",
                  "ohChargeAmt": 0.00,
                  "ohDiscAmt": 0.00,
                  "ohDistAmt": 15.00,
                  "ohDutyAmt": 0.00,
                  "ohTaxAmt": 0.00,
                  "ohTaxAmt2": 0.00,
                  "ohPrItem": "001",
                  "ohMisc": "HEAT"
                }
              ],
              "count": 1
            }